-- INSERT for table AUTOSC.CFG_PRC_TO_TASK_CATEGORY
INSERT INTO AUTOSC.CFG_PRC_TO_TASK_CATEGORY(ID,SERVER_NAME,TASK_CATEGORY_ID,CONCURRENT_CONSUMERS,MAX_CONCURRENT_CONSUMERS) VALUES (CFG_PRC_TO_TASK_CATEGORY_SEQ.nextVal,'Process-1',(SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='SWEEP'),10,20);
INSERT INTO AUTOSC.CFG_PRC_TO_TASK_CATEGORY(ID,SERVER_NAME,TASK_CATEGORY_ID,CONCURRENT_CONSUMERS,MAX_CONCURRENT_CONSUMERS) VALUES (CFG_PRC_TO_TASK_CATEGORY_SEQ.nextVal,'Process-1',(SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='NOTIFY'),5,20);
INSERT INTO AUTOSC.CFG_PRC_TO_TASK_CATEGORY(ID,SERVER_NAME,TASK_CATEGORY_ID,CONCURRENT_CONSUMERS,MAX_CONCURRENT_CONSUMERS) VALUES (CFG_PRC_TO_TASK_CATEGORY_SEQ.nextVal,'Process-1',(SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='GATHER'),5,20);
INSERT INTO AUTOSC.CFG_PRC_TO_TASK_CATEGORY(ID,SERVER_NAME,TASK_CATEGORY_ID,CONCURRENT_CONSUMERS,MAX_CONCURRENT_CONSUMERS) VALUES (CFG_PRC_TO_TASK_CATEGORY_SEQ.nextVal,'Process-1',(SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='SHEM'),5,10);
INSERT INTO AUTOSC.CFG_PRC_TO_TASK_CATEGORY(ID,SERVER_NAME,TASK_CATEGORY_ID,CONCURRENT_CONSUMERS,MAX_CONCURRENT_CONSUMERS) VALUES (CFG_PRC_TO_TASK_CATEGORY_SEQ.nextVal,'Process-1',(SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='DEFAULT'),1,1);
INSERT INTO AUTOSC.CFG_PRC_TO_TASK_CATEGORY(ID,SERVER_NAME,TASK_CATEGORY_ID,CONCURRENT_CONSUMERS,MAX_CONCURRENT_CONSUMERS) VALUES (CFG_PRC_TO_TASK_CATEGORY_SEQ.nextVal,'Process-1',(SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='ONWATCH'),5,10);
INSERT INTO AUTOSC.CFG_PRC_TO_TASK_CATEGORY(ID,SERVER_NAME,TASK_CATEGORY_ID,CONCURRENT_CONSUMERS,MAX_CONCURRENT_CONSUMERS) VALUES (CFG_PRC_TO_TASK_CATEGORY_SEQ.nextVal,'Process-2',(SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='SWEEP'),10,20);
INSERT INTO AUTOSC.CFG_PRC_TO_TASK_CATEGORY(ID,SERVER_NAME,TASK_CATEGORY_ID,CONCURRENT_CONSUMERS,MAX_CONCURRENT_CONSUMERS) VALUES (CFG_PRC_TO_TASK_CATEGORY_SEQ.nextVal,'Process-2',(SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='NOTIFY'),5,20);
INSERT INTO AUTOSC.CFG_PRC_TO_TASK_CATEGORY(ID,SERVER_NAME,TASK_CATEGORY_ID,CONCURRENT_CONSUMERS,MAX_CONCURRENT_CONSUMERS) VALUES (CFG_PRC_TO_TASK_CATEGORY_SEQ.nextVal,'Process-2',(SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='GATHER'),5,20);
INSERT INTO AUTOSC.CFG_PRC_TO_TASK_CATEGORY(ID,SERVER_NAME,TASK_CATEGORY_ID,CONCURRENT_CONSUMERS,MAX_CONCURRENT_CONSUMERS) VALUES (CFG_PRC_TO_TASK_CATEGORY_SEQ.nextVal,'Process-2',(SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='SHEM'),5,10);
INSERT INTO AUTOSC.CFG_PRC_TO_TASK_CATEGORY(ID,SERVER_NAME,TASK_CATEGORY_ID,CONCURRENT_CONSUMERS,MAX_CONCURRENT_CONSUMERS) VALUES (CFG_PRC_TO_TASK_CATEGORY_SEQ.nextVal,'Process-2',(SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='DEFAULT'),1,1);
INSERT INTO AUTOSC.CFG_PRC_TO_TASK_CATEGORY(ID,SERVER_NAME,TASK_CATEGORY_ID,CONCURRENT_CONSUMERS,MAX_CONCURRENT_CONSUMERS) VALUES (CFG_PRC_TO_TASK_CATEGORY_SEQ.nextVal,'Process-2',(SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='ONWATCH'),5,10);
INSERT INTO AUTOSC.CFG_PRC_TO_TASK_CATEGORY(ID,SERVER_NAME,TASK_CATEGORY_ID,CONCURRENT_CONSUMERS,MAX_CONCURRENT_CONSUMERS) VALUES (CFG_PRC_TO_TASK_CATEGORY_SEQ.nextVal,'Process-3',(SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='SWEEP'),10,20);
INSERT INTO AUTOSC.CFG_PRC_TO_TASK_CATEGORY(ID,SERVER_NAME,TASK_CATEGORY_ID,CONCURRENT_CONSUMERS,MAX_CONCURRENT_CONSUMERS) VALUES (CFG_PRC_TO_TASK_CATEGORY_SEQ.nextVal,'Process-3',(SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='NOTIFY'),5,20);
INSERT INTO AUTOSC.CFG_PRC_TO_TASK_CATEGORY(ID,SERVER_NAME,TASK_CATEGORY_ID,CONCURRENT_CONSUMERS,MAX_CONCURRENT_CONSUMERS) VALUES (CFG_PRC_TO_TASK_CATEGORY_SEQ.nextVal,'Process-3',(SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='GATHER'),5,20);
INSERT INTO AUTOSC.CFG_PRC_TO_TASK_CATEGORY(ID,SERVER_NAME,TASK_CATEGORY_ID,CONCURRENT_CONSUMERS,MAX_CONCURRENT_CONSUMERS) VALUES (CFG_PRC_TO_TASK_CATEGORY_SEQ.nextVal,'Process-3',(SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='SHEM'),5,10);
INSERT INTO AUTOSC.CFG_PRC_TO_TASK_CATEGORY(ID,SERVER_NAME,TASK_CATEGORY_ID,CONCURRENT_CONSUMERS,MAX_CONCURRENT_CONSUMERS) VALUES (CFG_PRC_TO_TASK_CATEGORY_SEQ.nextVal,'Process-3',(SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='DEFAULT'),1,1);
INSERT INTO AUTOSC.CFG_PRC_TO_TASK_CATEGORY(ID,SERVER_NAME,TASK_CATEGORY_ID,CONCURRENT_CONSUMERS,MAX_CONCURRENT_CONSUMERS) VALUES (CFG_PRC_TO_TASK_CATEGORY_SEQ.nextVal,'Process-3',(SELECT TASK_CATEGORY_ID FROM AUTOSC.CFG_TASK_CATEGORY_INFO WHERE TASK_CATEGORY='ONWATCH'),5,10);

COMMIT;